Pandas Profiling Report

Dataset statistics

Number of variables	33
Number of observations	119390
Missing cells	130601
Missing cells (%)	3.3%
Duplicate rows	0
Duplicate rows (%)	0.0%
Total size in memory	30.1 MiB
Average record size in memory	264.0 B

Variable types

Numeric	15
Categorical	18

Alerts

`country` has a high cardinality: 177 distinct values	High cardinality
`reservation_status_date` has a high cardinality: 926 distinct values	High cardinality
`arrival_date_year` is highly correlated with `arrival_date_week_number`	High correlation
`arrival_date_week_number` is highly correlated with `arrival_date_year`	High correlation
`is_repeated_guest` is highly correlated with `previous_bookings_not_canceled`	High correlation
`previous_bookings_not_canceled` is highly correlated with `is_repeated_guest`	High correlation
`arrival_date_year` is highly correlated with `arrival_date_week_number`	High correlation
`arrival_date_week_number` is highly correlated with `arrival_date_year`	High correlation
`is_repeated_guest` is highly correlated with `previous_bookings_not_canceled`	High correlation
`previous_bookings_not_canceled` is highly correlated with `is_repeated_guest`	High correlation
`market_segment` is highly correlated with `distribution_channel`	High correlation
`reserved_room_type` is highly correlated with `assigned_room_type`	High correlation
`reservation_status` is highly correlated with `is_canceled`	High correlation
`is_canceled` is highly correlated with `reservation_status`	High correlation
`assigned_room_type` is highly correlated with `reserved_room_type`	High correlation
`distribution_channel` is highly correlated with `market_segment`	High correlation
`Unnamed: 0` is highly correlated with `hotel` and 6 other fields	High correlation
`hotel` is highly correlated with `Unnamed: 0` and 3 other fields	High correlation
`is_canceled` is highly correlated with `Unnamed: 0` and 1 other fields	High correlation
`lead_time` is highly correlated with `company`	High correlation
`arrival_date_year` is highly correlated with `Unnamed: 0` and 2 other fields	High correlation
`arrival_date_month` is highly correlated with `Unnamed: 0` and 2 other fields	High correlation
`arrival_date_week_number` is highly correlated with `Unnamed: 0` and 3 other fields	High correlation
`stays_in_weekend_nights` is highly correlated with `stays_in_week_nights` and 1 other fields	High correlation
`stays_in_week_nights` is highly correlated with `stays_in_weekend_nights`	High correlation
`children` is highly correlated with `reserved_room_type`	High correlation
`market_segment` is highly correlated with `distribution_channel` and 1 other fields	High correlation
`distribution_channel` is highly correlated with `market_segment`	High correlation
`previous_cancellations` is highly correlated with `previous_bookings_not_canceled`	High correlation
`previous_bookings_not_canceled` is highly correlated with `previous_cancellations`	High correlation
`reserved_room_type` is highly correlated with `children` and 1 other fields	High correlation
`assigned_room_type` is highly correlated with `hotel` and 1 other fields	High correlation
`booking_changes` is highly correlated with `stays_in_weekend_nights`	High correlation
`deposit_type` is highly correlated with `reservation_status`	High correlation
`agent` is highly correlated with `hotel` and 1 other fields	High correlation
`company` is highly correlated with `Unnamed: 0` and 5 other fields	High correlation
`reservation_status` is highly correlated with `Unnamed: 0` and 2 other fields	High correlation
`agent` has 16340 (13.7%) missing values	Missing
`company` has 112593 (94.3%) missing values	Missing
`previous_cancellations` is highly skewed (γ1 = 24.45804872)	Skewed
`previous_bookings_not_canceled` is highly skewed (γ1 = 23.53979995)	Skewed
`Unnamed: 0` is uniformly distributed	Uniform
`Unnamed: 0` has unique values	Unique
`lead_time` has 6345 (5.3%) zeros	Zeros
`stays_in_weekend_nights` has 51998 (43.6%) zeros	Zeros
`stays_in_week_nights` has 7645 (6.4%) zeros	Zeros
`previous_cancellations` has 112906 (94.6%) zeros	Zeros
`previous_bookings_not_canceled` has 115770 (97.0%) zeros	Zeros
`booking_changes` has 101314 (84.9%) zeros	Zeros
`days_in_waiting_list` has 115692 (96.9%) zeros	Zeros
`adr` has 1959 (1.6%) zeros	Zeros
`total_of_special_requests` has 70318 (58.9%) zeros	Zeros

Reproduction

Analysis started	2022-07-25 13:16:14.054874
Analysis finished	2022-07-25 13:16:51.590928
Duration	37.54 seconds
Software version	pandas-profiling v3.2.0
Download configuration	config.json

Unnamed: 0
Real number (ℝ_≥0)

HIGH CORRELATION
UNIFORM
UNIQUE

Distinct	119390
Distinct (%)	100.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	59694.5

Minimum	0
Maximum	119389
Zeros	1
Zeros (%)	< 0.1%
Negative	0
Negative (%)	0.0%
Memory size	932.9 KiB

Quantile statistics

Minimum	0
5-th percentile	5969.45
Q1	29847.25
median	59694.5
Q3	89541.75
95-th percentile	113419.55
Maximum	119389
Range	119389
Interquartile range (IQR)	59694.5

Descriptive statistics

Standard deviation	34465.06866
Coefficient of variation (CV)	0.577357523
Kurtosis	-1.2
Mean	59694.5
Median Absolute Deviation (MAD)	29847.5
Skewness	0
Sum	7126926355
Variance	1187840958
Monotonicity	Strictly increasing

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	1	< 0.1%
79589	1	< 0.1%
79601	1	< 0.1%
79600	1	< 0.1%
79599	1	< 0.1%
79598	1	< 0.1%
79597	1	< 0.1%
79596	1	< 0.1%
79595	1	< 0.1%
79594	1	< 0.1%
Other values (119380)	119380	> 99.9%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	1	< 0.1%
1	1	< 0.1%
2	1	< 0.1%
3	1	< 0.1%
4	1	< 0.1%
5	1	< 0.1%
6	1	< 0.1%
7	1	< 0.1%
8	1	< 0.1%
9	1	< 0.1%

Value	Count	Frequency (%)
119389	1	< 0.1%
119388	1	< 0.1%
119387	1	< 0.1%
119386	1	< 0.1%
119385	1	< 0.1%
119384	1	< 0.1%
119383	1	< 0.1%
119382	1	< 0.1%
119381	1	< 0.1%
119380	1	< 0.1%

hotel
Categorical

HIGH CORRELATION

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	932.9 KiB

City Hotel	79330
Resort Hotel	40060

Length

Max length	12
Median length	10
Mean length	10.67107798
Min length	10

Characters and Unicode

Total characters	1274020
Distinct characters	12
Distinct categories	3 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	City Hotel
2nd row	City Hotel
3rd row	City Hotel
4th row	City Hotel
5th row	City Hotel

Common Values

Value	Count	Frequency (%)
City Hotel	79330	66.4%
Resort Hotel	40060	33.6%

Length

Histogram of lengths of the category

Category Frequency Plot

Value	Count	Frequency (%)
hotel	119390	50.0%
city	79330	33.2%
resort	40060	16.8%

Most occurring characters

Value	Count	Frequency (%)
t	238780	18.7%
o	159450	12.5%
e	159450	12.5%
	119390	9.4%
H	119390	9.4%
l	119390	9.4%
C	79330	6.2%
i	79330	6.2%
y	79330	6.2%
R	40060	3.1%
Other values (2)	80120	6.3%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	915850	71.9%
Uppercase Letter	238780	18.7%
Space Separator	119390	9.4%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
t	238780	26.1%
o	159450	17.4%
e	159450	17.4%
l	119390	13.0%
i	79330	8.7%
y	79330	8.7%
s	40060	4.4%
r	40060	4.4%

Uppercase Letter

Value	Count	Frequency (%)
H	119390	50.0%
C	79330	33.2%
R	40060	16.8%

Space Separator

Value	Count	Frequency (%)
	119390	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	1154630	90.6%
Common	119390	9.4%

Most frequent character per script

Latin

Value	Count	Frequency (%)
t	238780	20.7%
o	159450	13.8%
e	159450	13.8%
H	119390	10.3%
l	119390	10.3%
C	79330	6.9%
i	79330	6.9%
y	79330	6.9%
R	40060	3.5%
s	40060	3.5%

Common

Value	Count	Frequency (%)
	119390	100.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	1274020	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
t	238780	18.7%
o	159450	12.5%
e	159450	12.5%
	119390	9.4%
H	119390	9.4%
l	119390	9.4%
C	79330	6.2%
i	79330	6.2%
y	79330	6.2%
R	40060	3.1%
Other values (2)	80120	6.3%

is_canceled
Categorical

HIGH CORRELATION
HIGH CORRELATION

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	932.9 KiB

0	75166
1	44224

Length

Max length	1
Median length	1
Mean length	1
Min length	1

Characters and Unicode

Total characters	119390
Distinct characters	2
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	1
2nd row	1
3rd row	1
4th row	1
5th row	1

Common Values

Value	Count	Frequency (%)
0	75166	63.0%
1	44224	37.0%

Length

Histogram of lengths of the category

Category Frequency Plot

Value	Count	Frequency (%)
0	75166	63.0%
1	44224	37.0%

Most occurring characters

Value	Count	Frequency (%)
0	75166	63.0%
1	44224	37.0%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	119390	100.0%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
0	75166	63.0%
1	44224	37.0%

Most occurring scripts

Value	Count	Frequency (%)
Common	119390	100.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
0	75166	63.0%
1	44224	37.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	119390	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
0	75166	63.0%
1	44224	37.0%

lead_time
Real number (ℝ_≥0)

HIGH CORRELATION
ZEROS

Distinct	479
Distinct (%)	0.4%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	104.0114164

Minimum	0
Maximum	737
Zeros	6345
Zeros (%)	5.3%
Negative	0
Negative (%)	0.0%
Memory size	932.9 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	18
median	69
Q3	160
95-th percentile	320
Maximum	737
Range	737
Interquartile range (IQR)	142

Descriptive statistics

Standard deviation	106.863097
Coefficient of variation (CV)	1.027416997
Kurtosis	1.696448849
Mean	104.0114164
Median Absolute Deviation (MAD)	60
Skewness	1.346549873
Sum	12417923
Variance	11419.72151
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	6345	5.3%
1	3460	2.9%
2	2069	1.7%
3	1816	1.5%
4	1715	1.4%
5	1565	1.3%
6	1445	1.2%
7	1331	1.1%
8	1138	1.0%
12	1079	0.9%
Other values (469)	97427	81.6%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	6345	5.3%
1	3460	2.9%
2	2069	1.7%
3	1816	1.5%
4	1715	1.4%
5	1565	1.3%
6	1445	1.2%
7	1331	1.1%
8	1138	1.0%
9	992	0.8%

Value	Count	Frequency (%)
737	1	< 0.1%
709	1	< 0.1%
629	17	< 0.1%
626	30	< 0.1%
622	17	< 0.1%
615	17	< 0.1%
608	17	< 0.1%
605	30	< 0.1%
601	17	< 0.1%
594	17	< 0.1%

arrival_date_year
Categorical

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION

Distinct	3
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	932.9 KiB

2016	56707
2017	40687
2015	21996

Length

Max length	4
Median length	4
Mean length	4
Min length	4

Characters and Unicode

Total characters	477560
Distinct characters	6
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	2017
2nd row	2017
3rd row	2017
4th row	2017
5th row	2017

Common Values

Value	Count	Frequency (%)
2016	56707	47.5%
2017	40687	34.1%
2015	21996	18.4%

Length

Histogram of lengths of the category

Category Frequency Plot

Value	Count	Frequency (%)
2016	56707	47.5%
2017	40687	34.1%
2015	21996	18.4%

Most occurring characters

Value	Count	Frequency (%)
2	119390	25.0%
0	119390	25.0%
1	119390	25.0%
6	56707	11.9%
7	40687	8.5%
5	21996	4.6%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	477560	100.0%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
2	119390	25.0%
0	119390	25.0%
1	119390	25.0%
6	56707	11.9%
7	40687	8.5%
5	21996	4.6%

Most occurring scripts

Value	Count	Frequency (%)
Common	477560	100.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
2	119390	25.0%
0	119390	25.0%
1	119390	25.0%
6	56707	11.9%
7	40687	8.5%
5	21996	4.6%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	477560	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
2	119390	25.0%
0	119390	25.0%
1	119390	25.0%
6	56707	11.9%
7	40687	8.5%
5	21996	4.6%

arrival_date_month
Categorical

HIGH CORRELATION

Distinct	12
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	932.9 KiB

August	13877
July	12661
May	11791
October	11160
April	11089
Other values (7)	58812

Length

Max length	9
Median length	7
Mean length	5.903182846
Min length	3

Characters and Unicode

Total characters	704781
Distinct characters	26
Distinct categories	2 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	March
2nd row	March
3rd row	March
4th row	March
5th row	March

Common Values

Value	Count	Frequency (%)
August	13877	11.6%
July	12661	10.6%
May	11791	9.9%
October	11160	9.3%
April	11089	9.3%
June	10939	9.2%
September	10508	8.8%
March	9794	8.2%
February	8068	6.8%
November	6794	5.7%
Other values (2)	12709	10.6%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
august	13877	11.6%
july	12661	10.6%
may	11791	9.9%
october	11160	9.3%
april	11089	9.3%
june	10939	9.2%
september	10508	8.8%
march	9794	8.2%
february	8068	6.8%
november	6794	5.7%
Other values (2)	12709	10.6%

Most occurring characters

Value	Count	Frequency (%)
e	95619	13.6%
r	78190	11.1%
u	65351	9.3%
b	43310	6.1%
a	41511	5.9%
y	38449	5.5%
t	35545	5.0%
J	29529	4.2%
c	27734	3.9%
A	24966	3.5%
Other values (16)	224577	31.9%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	585391	83.1%
Uppercase Letter	119390	16.9%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
e	95619	16.3%
r	78190	13.4%
u	65351	11.2%
b	43310	7.4%
a	41511	7.1%
y	38449	6.6%
t	35545	6.1%
c	27734	4.7%
m	24082	4.1%
l	23750	4.1%
Other values (8)	111850	19.1%

Uppercase Letter

Value	Count	Frequency (%)
J	29529	24.7%
A	24966	20.9%
M	21585	18.1%
O	11160	9.3%
S	10508	8.8%
F	8068	6.8%
N	6794	5.7%
D	6780	5.7%

Most occurring scripts

Value	Count	Frequency (%)
Latin	704781	100.0%

Most frequent character per script

Latin

Value	Count	Frequency (%)
e	95619	13.6%
r	78190	11.1%
u	65351	9.3%
b	43310	6.1%
a	41511	5.9%
y	38449	5.5%
t	35545	5.0%
J	29529	4.2%
c	27734	3.9%
A	24966	3.5%
Other values (16)	224577	31.9%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	704781	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
e	95619	13.6%
r	78190	11.1%
u	65351	9.3%
b	43310	6.1%
a	41511	5.9%
y	38449	5.5%
t	35545	5.0%
J	29529	4.2%
c	27734	3.9%
A	24966	3.5%
Other values (16)	224577	31.9%

arrival_date_week_number
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION

Distinct	53
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	27.16517296

Minimum	1
Maximum	53
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	932.9 KiB

Quantile statistics

Minimum	1
5-th percentile	5
Q1	16
median	28
Q3	38
95-th percentile	49
Maximum	53
Range	52
Interquartile range (IQR)	22

Descriptive statistics

Standard deviation	13.60513836
Coefficient of variation (CV)	0.500830176
Kurtosis	-0.9860771763
Mean	27.16517296
Median Absolute Deviation (MAD)	11
Skewness	-0.01001432604
Sum	3243250
Variance	185.0997897
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
33	3580	3.0%
30	3087	2.6%
32	3045	2.6%
34	3040	2.5%
18	2926	2.5%
21	2854	2.4%
28	2853	2.4%
17	2805	2.3%
20	2785	2.3%
29	2763	2.3%
Other values (43)	89652	75.1%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1	1047	0.9%
2	1218	1.0%
3	1319	1.1%
4	1487	1.2%
5	1387	1.2%
6	1508	1.3%
7	2109	1.8%
8	2216	1.9%
9	2117	1.8%
10	2149	1.8%

Value	Count	Frequency (%)
53	1816	1.5%
52	1195	1.0%
51	933	0.8%
50	1505	1.3%
49	1782	1.5%
48	1504	1.3%
47	1685	1.4%
46	1574	1.3%
45	1941	1.6%
44	2272	1.9%

arrival_date_day_of_month
Real number (ℝ_≥0)

Distinct	31
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	15.79824106

Minimum	1
Maximum	31
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	932.9 KiB

Quantile statistics

Minimum	1
5-th percentile	2
Q1	8
median	16
Q3	23
95-th percentile	30
Maximum	31
Range	30
Interquartile range (IQR)	15

Descriptive statistics

Standard deviation	8.780829471
Coefficient of variation (CV)	0.5558105765
Kurtosis	-1.187168319
Mean	15.79824106
Median Absolute Deviation (MAD)	8
Skewness	-0.002000453979
Sum	1886152
Variance	77.10296619
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=31)

Value	Count	Frequency (%)
17	4406	3.7%
5	4317	3.6%
15	4196	3.5%
25	4160	3.5%
26	4147	3.5%
9	4096	3.4%
12	4087	3.4%
16	4078	3.4%
2	4055	3.4%
19	4052	3.4%
Other values (21)	77796	65.2%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1	3626	3.0%
2	4055	3.4%
3	3855	3.2%
4	3763	3.2%
5	4317	3.6%
6	3833	3.2%
7	3665	3.1%
8	3921	3.3%
9	4096	3.4%
10	3575	3.0%

Value	Count	Frequency (%)
31	2208	1.8%
30	3853	3.2%
29	3580	3.0%
28	3946	3.3%
27	3802	3.2%
26	4147	3.5%
25	4160	3.5%
24	3993	3.3%
23	3616	3.0%
22	3596	3.0%

stays_in_weekend_nights
Real number (ℝ_≥0)

HIGH CORRELATION
ZEROS

Distinct	17
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	0.9275986264

Minimum	0
Maximum	19
Zeros	51998
Zeros (%)	43.6%
Negative	0
Negative (%)	0.0%
Memory size	932.9 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	1
Q3	2
95-th percentile	2
Maximum	19
Range	19
Interquartile range (IQR)	2

Descriptive statistics

Standard deviation	0.9986134946
Coefficient of variation (CV)	1.076557755
Kurtosis	7.174066064
Mean	0.9275986264
Median Absolute Deviation (MAD)	1
Skewness	1.38004645
Sum	110746
Variance	0.9972289116
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=17)

Value	Count	Frequency (%)
0	51998	43.6%
2	33308	27.9%
1	30626	25.7%
4	1855	1.6%
3	1259	1.1%
6	153	0.1%
5	79	0.1%
8	60	0.1%
7	19	< 0.1%
9	11	< 0.1%
Other values (7)	22	< 0.1%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	51998	43.6%
1	30626	25.7%
2	33308	27.9%
3	1259	1.1%
4	1855	1.6%
5	79	0.1%
6	153	0.1%
7	19	< 0.1%
8	60	0.1%
9	11	< 0.1%

Value	Count	Frequency (%)
19	1	< 0.1%
18	1	< 0.1%
16	3	< 0.1%
14	2	< 0.1%
13	3	< 0.1%
12	5	< 0.1%
10	7	< 0.1%
9	11	< 0.1%
8	60	0.1%
7	19	< 0.1%

stays_in_week_nights
Real number (ℝ_≥0)

HIGH CORRELATION
ZEROS

Distinct	35
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	2.500301533

Minimum	0
Maximum	50
Zeros	7645
Zeros (%)	6.4%
Negative	0
Negative (%)	0.0%
Memory size	932.9 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	1
median	2
Q3	3
95-th percentile	5
Maximum	50
Range	50
Interquartile range (IQR)	2

Descriptive statistics

Standard deviation	1.908285615
Coefficient of variation (CV)	0.7632221914
Kurtosis	24.28455482
Mean	2.500301533
Median Absolute Deviation (MAD)	1
Skewness	2.862249242
Sum	298511
Variance	3.641553989
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=35)

Value	Count	Frequency (%)
2	33684	28.2%
1	30310	25.4%
3	22258	18.6%
5	11077	9.3%
4	9563	8.0%
0	7645	6.4%
6	1499	1.3%
10	1036	0.9%
7	1029	0.9%
8	656	0.5%
Other values (25)	633	0.5%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	7645	6.4%
1	30310	25.4%
2	33684	28.2%
3	22258	18.6%
4	9563	8.0%
5	11077	9.3%
6	1499	1.3%
7	1029	0.9%
8	656	0.5%
9	231	0.2%

Value	Count	Frequency (%)
50	1	< 0.1%
42	1	< 0.1%
41	1	< 0.1%
40	2	< 0.1%
35	1	< 0.1%
34	1	< 0.1%
33	1	< 0.1%
32	1	< 0.1%
30	5	< 0.1%
26	1	< 0.1%

adults
Real number (ℝ_≥0)

Distinct	14
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	1.856403384

Minimum	0
Maximum	55
Zeros	403
Zeros (%)	0.3%
Negative	0
Negative (%)	0.0%
Memory size	932.9 KiB

Quantile statistics

Minimum	0
5-th percentile	1
Q1	2
median	2
Q3	2
95-th percentile	3
Maximum	55
Range	55
Interquartile range (IQR)	0

Descriptive statistics

Standard deviation	0.5792609988
Coefficient of variation (CV)	0.3120340137
Kurtosis	1352.115116
Mean	1.856403384
Median Absolute Deviation (MAD)	0
Skewness	18.31780476
Sum	221636
Variance	0.3355433048
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=14)

Value	Count	Frequency (%)
2	89680	75.1%
1	23027	19.3%
3	6202	5.2%
0	403	0.3%
4	62	0.1%
26	5	< 0.1%
27	2	< 0.1%
20	2	< 0.1%
5	2	< 0.1%
40	1	< 0.1%
Other values (4)	4	< 0.1%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	403	0.3%
1	23027	19.3%
2	89680	75.1%
3	6202	5.2%
4	62	0.1%
5	2	< 0.1%
6	1	< 0.1%
10	1	< 0.1%
20	2	< 0.1%
26	5	< 0.1%

Value	Count	Frequency (%)
55	1	< 0.1%
50	1	< 0.1%
40	1	< 0.1%
27	2	< 0.1%
26	5	< 0.1%
20	2	< 0.1%
10	1	< 0.1%
6	1	< 0.1%
5	2	< 0.1%
4	62	0.1%

children
Categorical

HIGH CORRELATION

Distinct	5
Distinct (%)	< 0.1%
Missing	4
Missing (%)	< 0.1%
Memory size	932.9 KiB

0.0	110796
1.0	4861
2.0	3652
3.0	76
10.0	1

Length

Max length	4
Median length	3
Mean length	3.000008376
Min length	3

Characters and Unicode

Total characters	358159
Distinct characters	5
Distinct categories	2 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	1 ?
Unique (%)	< 0.1%

Sample

1st row	0.0
2nd row	0.0
3rd row	0.0
4th row	0.0
5th row	0.0

Common Values

Value	Count	Frequency (%)
0.0	110796	92.8%
1.0	4861	4.1%
2.0	3652	3.1%
3.0	76	0.1%
10.0	1	< 0.1%
(Missing)	4	< 0.1%

Length

Histogram of lengths of the category

Category Frequency Plot

Value	Count	Frequency (%)
0.0	110796	92.8%
1.0	4861	4.1%
2.0	3652	3.1%
3.0	76	0.1%
10.0	1	< 0.1%

Most occurring characters

Value	Count	Frequency (%)
0	230183	64.3%
.	119386	33.3%
1	4862	1.4%
2	3652	1.0%
3	76	< 0.1%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	238773	66.7%
Other Punctuation	119386	33.3%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
0	230183	96.4%
1	4862	2.0%
2	3652	1.5%
3	76	< 0.1%

Other Punctuation

Value	Count	Frequency (%)
.	119386	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Common	358159	100.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
0	230183	64.3%
.	119386	33.3%
1	4862	1.4%
2	3652	1.0%
3	76	< 0.1%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	358159	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
0	230183	64.3%
.	119386	33.3%
1	4862	1.4%
2	3652	1.0%
3	76	< 0.1%

babies
Categorical

Distinct	5
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	932.9 KiB

0	118473
1	900
2	15
9	1
10	1

Length

Max length	2
Median length	1
Mean length	1.000008376
Min length	1

Characters and Unicode

Total characters	119391
Distinct characters	4
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	2 ?
Unique (%)	< 0.1%

Sample

1st row	0
2nd row	0
3rd row	0
4th row	0
5th row	0

Common Values

Value	Count	Frequency (%)
0	118473	99.2%
1	900	0.8%
2	15	< 0.1%
9	1	< 0.1%
10	1	< 0.1%

Length

Histogram of lengths of the category

Category Frequency Plot

Value	Count	Frequency (%)
0	118473	99.2%
1	900	0.8%
2	15	< 0.1%
9	1	< 0.1%
10	1	< 0.1%

Most occurring characters

Value	Count	Frequency (%)
0	118474	99.2%
1	901	0.8%
2	15	< 0.1%
9	1	< 0.1%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	119391	100.0%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
0	118474	99.2%
1	901	0.8%
2	15	< 0.1%
9	1	< 0.1%

Most occurring scripts

Value	Count	Frequency (%)
Common	119391	100.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
0	118474	99.2%
1	901	0.8%
2	15	< 0.1%
9	1	< 0.1%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	119391	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
0	118474	99.2%
1	901	0.8%
2	15	< 0.1%
9	1	< 0.1%

meal
Categorical

Distinct	4
Distinct (%)	< 0.1%
Missing	1169
Missing (%)	1.0%
Memory size	932.9 KiB

BB	92310
HB	14463
SC	10650
FB	798

Length

Max length	2
Median length	2
Mean length	2
Min length	2

Characters and Unicode

Total characters	236442
Distinct characters	5
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	BB
2nd row	BB
3rd row	BB
4th row	BB
5th row	BB

Common Values

Value	Count	Frequency (%)
BB	92310	77.3%
HB	14463	12.1%
SC	10650	8.9%
FB	798	0.7%
(Missing)	1169	1.0%

Length

Histogram of lengths of the category

Category Frequency Plot

Value	Count	Frequency (%)
bb	92310	78.1%
hb	14463	12.2%
sc	10650	9.0%
fb	798	0.7%

Most occurring characters

Value	Count	Frequency (%)
B	199881	84.5%
H	14463	6.1%
S	10650	4.5%
C	10650	4.5%
F	798	0.3%

Most occurring categories

Value	Count	Frequency (%)
Uppercase Letter	236442	100.0%

Most frequent character per category

Uppercase Letter

Value	Count	Frequency (%)
B	199881	84.5%
H	14463	6.1%
S	10650	4.5%
C	10650	4.5%
F	798	0.3%

Most occurring scripts

Value	Count	Frequency (%)
Latin	236442	100.0%

Most frequent character per script

Latin

Value	Count	Frequency (%)
B	199881	84.5%
H	14463	6.1%
S	10650	4.5%
C	10650	4.5%
F	798	0.3%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	236442	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
B	199881	84.5%
H	14463	6.1%
S	10650	4.5%
C	10650	4.5%
F	798	0.3%

country
Categorical

HIGH CARDINALITY

Distinct	177
Distinct (%)	0.1%
Missing	488
Missing (%)	0.4%
Memory size	932.9 KiB

PRT	48590
GBR	12129
FRA	10415
ESP	8568
DEU	7287
Other values (172)	31913

Length

Max length	3
Median length	3
Mean length	2.989243242
Min length	2

Characters and Unicode

Total characters	355427
Distinct characters	26
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	30 ?
Unique (%)	< 0.1%

Sample

1st row	PRT
2nd row	PRT
3rd row	PRT
4th row	PRT
5th row	PRT

Common Values

Value	Count	Frequency (%)
PRT	48590	40.7%
GBR	12129	10.2%
FRA	10415	8.7%
ESP	8568	7.2%
DEU	7287	6.1%
ITA	3766	3.2%
IRL	3375	2.8%
BEL	2342	2.0%
BRA	2224	1.9%
NLD	2104	1.8%
Other values (167)	18102	15.2%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
prt	48590	40.9%
gbr	12129	10.2%
fra	10415	8.8%
esp	8568	7.2%
deu	7287	6.1%
ita	3766	3.2%
irl	3375	2.8%
bel	2342	2.0%
bra	2224	1.9%
nld	2104	1.8%
Other values (167)	18102	15.2%

Most occurring characters

Value	Count	Frequency (%)
R	80804	22.7%
P	58506	16.5%
T	54263	15.3%
A	21627	6.1%
E	21538	6.1%
B	17051	4.8%
S	13931	3.9%
U	13293	3.7%
G	13130	3.7%
F	10956	3.1%
Other values (16)	50328	14.2%

Most occurring categories

Value	Count	Frequency (%)
Uppercase Letter	355427	100.0%

Most frequent character per category

Uppercase Letter

Value	Count	Frequency (%)
R	80804	22.7%
P	58506	16.5%
T	54263	15.3%
A	21627	6.1%
E	21538	6.1%
B	17051	4.8%
S	13931	3.9%
U	13293	3.7%
G	13130	3.7%
F	10956	3.1%
Other values (16)	50328	14.2%

Most occurring scripts

Value	Count	Frequency (%)
Latin	355427	100.0%

Most frequent character per script

Latin

Value	Count	Frequency (%)
R	80804	22.7%
P	58506	16.5%
T	54263	15.3%
A	21627	6.1%
E	21538	6.1%
B	17051	4.8%
S	13931	3.9%
U	13293	3.7%
G	13130	3.7%
F	10956	3.1%
Other values (16)	50328	14.2%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	355427	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
R	80804	22.7%
P	58506	16.5%
T	54263	15.3%
A	21627	6.1%
E	21538	6.1%
B	17051	4.8%
S	13931	3.9%
U	13293	3.7%
G	13130	3.7%
F	10956	3.1%
Other values (16)	50328	14.2%

market_segment
Categorical

HIGH CORRELATION
HIGH CORRELATION

Distinct	7
Distinct (%)	< 0.1%
Missing	2
Missing (%)	< 0.1%
Memory size	932.9 KiB

Online TA	56477
Offline TA/TO	24219
Groups	19811
Direct	12606
Corporate	5295
Other values (2)	980

Length

Max length	13
Median length	9
Mean length	9.019767481
Min length	6

Characters and Unicode

Total characters	1076852
Distinct characters	24
Distinct categories	4 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Groups
2nd row	Groups
3rd row	Groups
4th row	Groups
5th row	Groups

Common Values

Value	Count	Frequency (%)
Online TA	56477	47.3%
Offline TA/TO	24219	20.3%
Groups	19811	16.6%
Direct	12606	10.6%
Corporate	5295	4.4%
Complementary	743	0.6%
Aviation	237	0.2%
(Missing)	2	< 0.1%

Length

Histogram of lengths of the category

Category Frequency Plot

Value	Count	Frequency (%)
online	56477	28.2%
ta	56477	28.2%
offline	24219	12.1%
ta/to	24219	12.1%
groups	19811	9.9%
direct	12606	6.3%
corporate	5295	2.6%
complementary	743	0.4%
aviation	237	0.1%

Most occurring characters

Value	Count	Frequency (%)
n	138153	12.8%
O	104915	9.7%
T	104915	9.7%
e	100083	9.3%
i	93776	8.7%
l	81439	7.6%
A	80933	7.5%
	80696	7.5%
f	48438	4.5%
r	43750	4.1%
Other values (14)	199754	18.5%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	642719	59.7%
Uppercase Letter	329218	30.6%
Space Separator	80696	7.5%
Other Punctuation	24219	2.2%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
n	138153	21.5%
e	100083	15.6%
i	93776	14.6%
l	81439	12.7%
f	48438	7.5%
r	43750	6.8%
o	31381	4.9%
p	25849	4.0%
u	19811	3.1%
s	19811	3.1%
Other values (6)	40228	6.3%

Uppercase Letter

Value	Count	Frequency (%)
O	104915	31.9%
T	104915	31.9%
A	80933	24.6%
G	19811	6.0%
D	12606	3.8%
C	6038	1.8%

Space Separator

Value	Count	Frequency (%)
	80696	100.0%

Other Punctuation

Value	Count	Frequency (%)
/	24219	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	971937	90.3%
Common	104915	9.7%

Most frequent character per script

Latin

Value	Count	Frequency (%)
n	138153	14.2%
O	104915	10.8%
T	104915	10.8%
e	100083	10.3%
i	93776	9.6%
l	81439	8.4%
A	80933	8.3%
f	48438	5.0%
r	43750	4.5%
o	31381	3.2%
Other values (12)	144154	14.8%

Common

Value	Count	Frequency (%)
	80696	76.9%
/	24219	23.1%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	1076852	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
n	138153	12.8%
O	104915	9.7%
T	104915	9.7%
e	100083	9.3%
i	93776	8.7%
l	81439	7.6%
A	80933	7.5%
	80696	7.5%
f	48438	4.5%
r	43750	4.1%
Other values (14)	199754	18.5%

distribution_channel
Categorical

HIGH CORRELATION
HIGH CORRELATION

Distinct	4
Distinct (%)	< 0.1%
Missing	5
Missing (%)	< 0.1%
Memory size	932.9 KiB

TA/TO	97870
Direct	14645
Corporate	6677
GDS	193

Length

Max length	9
Median length	5
Mean length	5.343150312
Min length	3

Characters and Unicode

Total characters	637892
Distinct characters	16
Distinct categories	3 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	TA/TO
2nd row	TA/TO
3rd row	TA/TO
4th row	TA/TO
5th row	TA/TO

Common Values

Value	Count	Frequency (%)
TA/TO	97870	82.0%
Direct	14645	12.3%
Corporate	6677	5.6%
GDS	193	0.2%
(Missing)	5	< 0.1%

Length

Histogram of lengths of the category

Category Frequency Plot

Value	Count	Frequency (%)
ta/to	97870	82.0%
direct	14645	12.3%
corporate	6677	5.6%
gds	193	0.2%

Most occurring characters

Value	Count	Frequency (%)
T	195740	30.7%
A	97870	15.3%
/	97870	15.3%
O	97870	15.3%
r	27999	4.4%
e	21322	3.3%
t	21322	3.3%
D	14838	2.3%
i	14645	2.3%
c	14645	2.3%
Other values (6)	33771	5.3%

Most occurring categories

Value	Count	Frequency (%)
Uppercase Letter	413381	64.8%
Lowercase Letter	126641	19.9%
Other Punctuation	97870	15.3%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
r	27999	22.1%
e	21322	16.8%
t	21322	16.8%
i	14645	11.6%
c	14645	11.6%
o	13354	10.5%
p	6677	5.3%
a	6677	5.3%

Uppercase Letter

Value	Count	Frequency (%)
T	195740	47.4%
A	97870	23.7%
O	97870	23.7%
D	14838	3.6%
C	6677	1.6%
G	193	< 0.1%
S	193	< 0.1%

Other Punctuation

Value	Count	Frequency (%)
/	97870	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	540022	84.7%
Common	97870	15.3%

Most frequent character per script

Latin

Value	Count	Frequency (%)
T	195740	36.2%
A	97870	18.1%
O	97870	18.1%
r	27999	5.2%
e	21322	3.9%
t	21322	3.9%
D	14838	2.7%
i	14645	2.7%
c	14645	2.7%
o	13354	2.5%
Other values (5)	20417	3.8%

Common

Value	Count	Frequency (%)
/	97870	100.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	637892	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
T	195740	30.7%
A	97870	15.3%
/	97870	15.3%
O	97870	15.3%
r	27999	4.4%
e	21322	3.3%
t	21322	3.3%
D	14838	2.3%
i	14645	2.3%
c	14645	2.3%
Other values (6)	33771	5.3%

is_repeated_guest
Categorical

HIGH CORRELATION
HIGH CORRELATION

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	932.9 KiB

0	115580
1	3810

Length

Max length	1
Median length	1
Mean length	1
Min length	1

Characters and Unicode

Total characters	119390
Distinct characters	2
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	0
2nd row	0
3rd row	0
4th row	0
5th row	0

Common Values

Value	Count	Frequency (%)
0	115580	96.8%
1	3810	3.2%

Length

Histogram of lengths of the category

Category Frequency Plot

Value	Count	Frequency (%)
0	115580	96.8%
1	3810	3.2%

Most occurring characters

Value	Count	Frequency (%)
0	115580	96.8%
1	3810	3.2%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	119390	100.0%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
0	115580	96.8%
1	3810	3.2%

Most occurring scripts

Value	Count	Frequency (%)
Common	119390	100.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
0	115580	96.8%
1	3810	3.2%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	119390	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
0	115580	96.8%
1	3810	3.2%

previous_cancellations
Real number (ℝ_≥0)

HIGH CORRELATION
SKEWED
ZEROS

Distinct	15
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	0.08711784907

Minimum	0
Maximum	26
Zeros	112906
Zeros (%)	94.6%
Negative	0
Negative (%)	0.0%
Memory size	932.9 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	0
95-th percentile	1
Maximum	26
Range	26
Interquartile range (IQR)	0

Descriptive statistics

Standard deviation	0.8443363842
Coefficient of variation (CV)	9.691887405
Kurtosis	674.0736926
Mean	0.08711784907
Median Absolute Deviation (MAD)	0
Skewness	24.45804872
Sum	10401
Variance	0.7129039296
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=15)

Value	Count	Frequency (%)
0	112906	94.6%
1	6051	5.1%
2	116	0.1%
3	65	0.1%
24	48	< 0.1%
11	35	< 0.1%
4	31	< 0.1%
26	26	< 0.1%
25	25	< 0.1%
6	22	< 0.1%
Other values (5)	65	0.1%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	112906	94.6%
1	6051	5.1%
2	116	0.1%
3	65	0.1%
4	31	< 0.1%
5	19	< 0.1%
6	22	< 0.1%
11	35	< 0.1%
13	12	< 0.1%
14	14	< 0.1%

Value	Count	Frequency (%)
26	26	< 0.1%
25	25	< 0.1%
24	48	< 0.1%
21	1	< 0.1%
19	19	< 0.1%
14	14	< 0.1%
13	12	< 0.1%
11	35	< 0.1%
6	22	< 0.1%
5	19	< 0.1%

previous_bookings_not_canceled
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
SKEWED
ZEROS

Distinct	73
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	0.1370969093

Minimum	0
Maximum	72
Zeros	115770
Zeros (%)	97.0%
Negative	0
Negative (%)	0.0%
Memory size	932.9 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	0
95-th percentile	0
Maximum	72
Range	72
Interquartile range (IQR)	0

Descriptive statistics

Standard deviation	1.497436848
Coefficient of variation (CV)	10.92246977
Kurtosis	767.2452097
Mean	0.1370969093
Median Absolute Deviation (MAD)	0
Skewness	23.53979995
Sum	16368
Variance	2.242317113
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	115770	97.0%
1	1542	1.3%
2	580	0.5%
3	333	0.3%
4	229	0.2%
5	181	0.2%
6	115	0.1%
7	88	0.1%
8	70	0.1%
9	60	0.1%
Other values (63)	422	0.4%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	115770	97.0%
1	1542	1.3%
2	580	0.5%
3	333	0.3%
4	229	0.2%
5	181	0.2%
6	115	0.1%
7	88	0.1%
8	70	0.1%
9	60	0.1%

Value	Count	Frequency (%)
72	1	< 0.1%
71	1	< 0.1%
70	1	< 0.1%
69	1	< 0.1%
68	1	< 0.1%
67	1	< 0.1%
66	1	< 0.1%
65	1	< 0.1%
64	1	< 0.1%
63	1	< 0.1%

reserved_room_type
Categorical

HIGH CORRELATION
HIGH CORRELATION

Distinct	10
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	932.9 KiB

A	85994
D	19201
E	6535
F	2897
G	2094
Other values (5)	2669

Length

Max length	1
Median length	1
Mean length	1
Min length	1

Characters and Unicode

Total characters	119390
Distinct characters	10
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	A
2nd row	A
3rd row	A
4th row	A
5th row	A

Common Values

Value	Count	Frequency (%)
A	85994	72.0%
D	19201	16.1%
E	6535	5.5%
F	2897	2.4%
G	2094	1.8%
B	1118	0.9%
C	932	0.8%
H	601	0.5%
P	12	< 0.1%
L	6	< 0.1%

Length

Histogram of lengths of the category

Category Frequency Plot

Value	Count	Frequency (%)
a	85994	72.0%
d	19201	16.1%
e	6535	5.5%
f	2897	2.4%
g	2094	1.8%
b	1118	0.9%
c	932	0.8%
h	601	0.5%
p	12	< 0.1%
l	6	< 0.1%

Most occurring characters

Value	Count	Frequency (%)
A	85994	72.0%
D	19201	16.1%
E	6535	5.5%
F	2897	2.4%
G	2094	1.8%
B	1118	0.9%
C	932	0.8%
H	601	0.5%
P	12	< 0.1%
L	6	< 0.1%

Most occurring categories

Value	Count	Frequency (%)
Uppercase Letter	119390	100.0%

Most frequent character per category

Uppercase Letter

Value	Count	Frequency (%)
A	85994	72.0%
D	19201	16.1%
E	6535	5.5%
F	2897	2.4%
G	2094	1.8%
B	1118	0.9%
C	932	0.8%
H	601	0.5%
P	12	< 0.1%
L	6	< 0.1%

Most occurring scripts

Value	Count	Frequency (%)
Latin	119390	100.0%

Most frequent character per script

Latin

Value	Count	Frequency (%)
A	85994	72.0%
D	19201	16.1%
E	6535	5.5%
F	2897	2.4%
G	2094	1.8%
B	1118	0.9%
C	932	0.8%
H	601	0.5%
P	12	< 0.1%
L	6	< 0.1%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	119390	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
A	85994	72.0%
D	19201	16.1%
E	6535	5.5%
F	2897	2.4%
G	2094	1.8%
B	1118	0.9%
C	932	0.8%
H	601	0.5%
P	12	< 0.1%
L	6	< 0.1%

assigned_room_type
Categorical

HIGH CORRELATION
HIGH CORRELATION

Distinct	12
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	932.9 KiB

A	74053
D	25322
E	7806
F	3751
G	2553
Other values (7)	5905

Length

Max length	1
Median length	1
Mean length	1
Min length	1

Characters and Unicode

Total characters	119390
Distinct characters	12
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	1 ?
Unique (%)	< 0.1%

Sample

1st row	A
2nd row	A
3rd row	A
4th row	A
5th row	A

Common Values

Value	Count	Frequency (%)
A	74053	62.0%
D	25322	21.2%
E	7806	6.5%
F	3751	3.1%
G	2553	2.1%
C	2375	2.0%
B	2163	1.8%
H	712	0.6%
I	363	0.3%
K	279	0.2%
Other values (2)	13	< 0.1%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
a	74053	62.0%
d	25322	21.2%
e	7806	6.5%
f	3751	3.1%
g	2553	2.1%
c	2375	2.0%
b	2163	1.8%
h	712	0.6%
i	363	0.3%
k	279	0.2%
Other values (2)	13	< 0.1%

Most occurring characters

Value	Count	Frequency (%)
A	74053	62.0%
D	25322	21.2%
E	7806	6.5%
F	3751	3.1%
G	2553	2.1%
C	2375	2.0%
B	2163	1.8%
H	712	0.6%
I	363	0.3%
K	279	0.2%
Other values (2)	13	< 0.1%

Most occurring categories

Value	Count	Frequency (%)
Uppercase Letter	119390	100.0%

Most frequent character per category

Uppercase Letter

Value	Count	Frequency (%)
A	74053	62.0%
D	25322	21.2%
E	7806	6.5%
F	3751	3.1%
G	2553	2.1%
C	2375	2.0%
B	2163	1.8%
H	712	0.6%
I	363	0.3%
K	279	0.2%
Other values (2)	13	< 0.1%

Most occurring scripts

Value	Count	Frequency (%)
Latin	119390	100.0%

Most frequent character per script

Latin

Value	Count	Frequency (%)
A	74053	62.0%
D	25322	21.2%
E	7806	6.5%
F	3751	3.1%
G	2553	2.1%
C	2375	2.0%
B	2163	1.8%
H	712	0.6%
I	363	0.3%
K	279	0.2%
Other values (2)	13	< 0.1%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	119390	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
A	74053	62.0%
D	25322	21.2%
E	7806	6.5%
F	3751	3.1%
G	2553	2.1%
C	2375	2.0%
B	2163	1.8%
H	712	0.6%
I	363	0.3%
K	279	0.2%
Other values (2)	13	< 0.1%

booking_changes
Real number (ℝ_≥0)

HIGH CORRELATION
ZEROS

Distinct	21
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	0.2211240472

Minimum	0
Maximum	21
Zeros	101314
Zeros (%)	84.9%
Negative	0
Negative (%)	0.0%
Memory size	932.9 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	0
95-th percentile	1
Maximum	21
Range	21
Interquartile range (IQR)	0

Descriptive statistics

Standard deviation	0.6523055727
Coefficient of variation (CV)	2.949953118
Kurtosis	79.39360467
Mean	0.2211240472
Median Absolute Deviation (MAD)	0
Skewness	6.000270054
Sum	26400
Variance	0.4255025601
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=21)

Value	Count	Frequency (%)
0	101314	84.9%
1	12701	10.6%
2	3805	3.2%
3	927	0.8%
4	376	0.3%
5	118	0.1%
6	63	0.1%
7	31	< 0.1%
8	17	< 0.1%
9	8	< 0.1%
Other values (11)	30	< 0.1%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	101314	84.9%
1	12701	10.6%
2	3805	3.2%
3	927	0.8%
4	376	0.3%
5	118	0.1%
6	63	0.1%
7	31	< 0.1%
8	17	< 0.1%
9	8	< 0.1%

Value	Count	Frequency (%)
21	1	< 0.1%
20	1	< 0.1%
18	1	< 0.1%
17	2	< 0.1%
16	2	< 0.1%
15	3	< 0.1%
14	5	< 0.1%
13	5	< 0.1%
12	2	< 0.1%
11	2	< 0.1%

deposit_type
Categorical

HIGH CORRELATION

Distinct	3
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	932.9 KiB

No Deposit	104641
Non Refund	14587
Refundable	162

Length

Max length	10
Median length	10
Mean length	10
Min length	10

Characters and Unicode

Total characters	1193900
Distinct characters	17
Distinct categories	3 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Non Refund
2nd row	Non Refund
3rd row	Non Refund
4th row	Non Refund
5th row	Non Refund

Common Values

Value	Count	Frequency (%)
No Deposit	104641	87.6%
Non Refund	14587	12.2%
Refundable	162	0.1%

Length

Histogram of lengths of the category

Category Frequency Plot

Value	Count	Frequency (%)
no	104641	43.9%
deposit	104641	43.9%
non	14587	6.1%
refund	14587	6.1%
refundable	162	0.1%

Most occurring characters

Value	Count	Frequency (%)
o	223869	18.8%
e	119552	10.0%
N	119228	10.0%
	119228	10.0%
s	104641	8.8%
i	104641	8.8%
t	104641	8.8%
p	104641	8.8%
D	104641	8.8%
n	29336	2.5%
Other values (7)	59482	5.0%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	836054	70.0%
Uppercase Letter	238618	20.0%
Space Separator	119228	10.0%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
o	223869	26.8%
e	119552	14.3%
s	104641	12.5%
i	104641	12.5%
t	104641	12.5%
p	104641	12.5%
n	29336	3.5%
f	14749	1.8%
u	14749	1.8%
d	14749	1.8%
Other values (3)	486	0.1%

Uppercase Letter

Value	Count	Frequency (%)
N	119228	50.0%
D	104641	43.9%
R	14749	6.2%

Space Separator

Value	Count	Frequency (%)
	119228	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	1074672	90.0%
Common	119228	10.0%

Most frequent character per script

Latin

Value	Count	Frequency (%)
o	223869	20.8%
e	119552	11.1%
N	119228	11.1%
s	104641	9.7%
i	104641	9.7%
t	104641	9.7%
p	104641	9.7%
D	104641	9.7%
n	29336	2.7%
R	14749	1.4%
Other values (6)	44733	4.2%

Common

Value	Count	Frequency (%)
	119228	100.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	1193900	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
o	223869	18.8%
e	119552	10.0%
N	119228	10.0%
	119228	10.0%
s	104641	8.8%
i	104641	8.8%
t	104641	8.8%
p	104641	8.8%
D	104641	8.8%
n	29336	2.5%
Other values (7)	59482	5.0%

agent
Real number (ℝ_≥0)

HIGH CORRELATION
MISSING

Distinct	333
Distinct (%)	0.3%
Missing	16340
Missing (%)	13.7%
Infinite	0
Infinite (%)	0.0%
Mean	86.69338185

Minimum	1
Maximum	535
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	932.9 KiB

Quantile statistics

Minimum	1
5-th percentile	1
Q1	9
median	14
Q3	229
95-th percentile	250
Maximum	535
Range	534
Interquartile range (IQR)	220

Descriptive statistics

Standard deviation	110.7745476
Coefficient of variation (CV)	1.277773981
Kurtosis	-0.007179564938
Mean	86.69338185
Median Absolute Deviation (MAD)	13
Skewness	1.089385636
Sum	8933753
Variance	12271.00041
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
9	31961	26.8%
240	13922	11.7%
1	7191	6.0%
14	3640	3.0%
7	3539	3.0%
6	3290	2.8%
250	2870	2.4%
241	1721	1.4%
28	1666	1.4%
8	1514	1.3%
Other values (323)	31736	26.6%
(Missing)	16340	13.7%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1	7191	6.0%
2	162	0.1%
3	1336	1.1%
4	47	< 0.1%
5	330	0.3%
6	3290	2.8%
7	3539	3.0%
8	1514	1.3%
9	31961	26.8%
10	260	0.2%

Value	Count	Frequency (%)
535	3	< 0.1%
531	68	0.1%
527	35	< 0.1%
526	10	< 0.1%
510	2	< 0.1%
509	10	< 0.1%
508	6	< 0.1%
502	24	< 0.1%
497	1	< 0.1%
495	57	< 0.1%

company
Real number (ℝ_≥0)

HIGH CORRELATION
MISSING

Distinct	352
Distinct (%)	5.2%
Missing	112593
Missing (%)	94.3%
Infinite	0
Infinite (%)	0.0%
Mean	189.2667353

Minimum	6
Maximum	543
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	932.9 KiB

Quantile statistics

Minimum	6
5-th percentile	40
Q1	62
median	179
Q3	270
95-th percentile	435
Maximum	543
Range	537
Interquartile range (IQR)	208

Descriptive statistics

Standard deviation	131.6550146
Coefficient of variation (CV)	0.6956056721
Kurtosis	-0.4907952103
Mean	189.2667353
Median Absolute Deviation (MAD)	111
Skewness	0.6015996673
Sum	1286446
Variance	17333.04288
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
40	927	0.8%
223	784	0.7%
67	267	0.2%
45	250	0.2%
153	215	0.2%
174	149	0.1%
219	141	0.1%
281	138	0.1%
154	133	0.1%
405	119	0.1%
Other values (342)	3674	3.1%
(Missing)	112593	94.3%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
6	1	< 0.1%
8	1	< 0.1%
9	37	< 0.1%
10	1	< 0.1%
11	1	< 0.1%
12	14	< 0.1%
14	9	< 0.1%
16	5	< 0.1%
18	1	< 0.1%
20	50	< 0.1%

Value	Count	Frequency (%)
543	2	< 0.1%
541	1	< 0.1%
539	2	< 0.1%
534	2	< 0.1%
531	1	< 0.1%
530	5	< 0.1%
528	2	< 0.1%
525	15	< 0.1%
523	19	< 0.1%
521	7	< 0.1%

days_in_waiting_list
Real number (ℝ_≥0)

ZEROS

Distinct	128
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	2.321149175

Minimum	0
Maximum	391
Zeros	115692
Zeros (%)	96.9%
Negative	0
Negative (%)	0.0%
Memory size	932.9 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	0
95-th percentile	0
Maximum	391
Range	391
Interquartile range (IQR)	0

Descriptive statistics

Standard deviation	17.59472088
Coefficient of variation (CV)	7.580176694
Kurtosis	186.7930696
Mean	2.321149175
Median Absolute Deviation (MAD)	0
Skewness	11.94435345
Sum	277122
Variance	309.5742028
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	115692	96.9%
39	227	0.2%
58	164	0.1%
44	141	0.1%
31	127	0.1%
35	96	0.1%
46	94	0.1%
69	89	0.1%
63	83	0.1%
50	80	0.1%
Other values (118)	2597	2.2%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	115692	96.9%
1	12	< 0.1%
2	5	< 0.1%
3	59	< 0.1%
4	25	< 0.1%
5	8	< 0.1%
6	16	< 0.1%
7	4	< 0.1%
8	7	< 0.1%
9	16	< 0.1%

Value	Count	Frequency (%)
391	45	< 0.1%
379	15	< 0.1%
330	15	< 0.1%
259	10	< 0.1%
236	35	< 0.1%
224	10	< 0.1%
223	61	0.1%
215	21	< 0.1%
207	15	< 0.1%
193	1	< 0.1%

customer_type
Categorical

Distinct	4
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	932.9 KiB

Transient	89613
Transient-Party	25124
Contract	4076
Group	577

Length

Max length	15
Median length	9
Mean length	10.20914649
Min length	5

Characters and Unicode

Total characters	1218870
Distinct characters	17
Distinct categories	3 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Transient
2nd row	Transient
3rd row	Transient
4th row	Transient
5th row	Transient

Common Values

Value	Count	Frequency (%)
Transient	89613	75.1%
Transient-Party	25124	21.0%
Contract	4076	3.4%
Group	577	0.5%

Length

Histogram of lengths of the category

Category Frequency Plot

Value	Count	Frequency (%)
transient	89613	75.1%
transient-party	25124	21.0%
contract	4076	3.4%
group	577	0.5%

Most occurring characters

Value	Count	Frequency (%)
n	233550	19.2%
t	148013	12.1%
r	144514	11.9%
a	143937	11.8%
T	114737	9.4%
s	114737	9.4%
i	114737	9.4%
e	114737	9.4%
y	25124	2.1%
-	25124	2.1%
Other values (7)	39660	3.3%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	1049232	86.1%
Uppercase Letter	144514	11.9%
Dash Punctuation	25124	2.1%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
n	233550	22.3%
t	148013	14.1%
r	144514	13.8%
a	143937	13.7%
s	114737	10.9%
i	114737	10.9%
e	114737	10.9%
y	25124	2.4%
o	4653	0.4%
c	4076	0.4%
Other values (2)	1154	0.1%

Uppercase Letter

Value	Count	Frequency (%)
T	114737	79.4%
P	25124	17.4%
C	4076	2.8%
G	577	0.4%

Dash Punctuation

Value	Count	Frequency (%)
-	25124	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	1193746	97.9%
Common	25124	2.1%

Most frequent character per script

Latin

Value	Count	Frequency (%)
n	233550	19.6%
t	148013	12.4%
r	144514	12.1%
a	143937	12.1%
T	114737	9.6%
s	114737	9.6%
i	114737	9.6%
e	114737	9.6%
y	25124	2.1%
P	25124	2.1%
Other values (6)	14536	1.2%

Common

Value	Count	Frequency (%)
-	25124	100.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	1218870	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
n	233550	19.2%
t	148013	12.1%
r	144514	11.9%
a	143937	11.8%
T	114737	9.4%
s	114737	9.4%
i	114737	9.4%
e	114737	9.4%
y	25124	2.1%
-	25124	2.1%
Other values (7)	39660	3.3%

adr
Real number (ℝ)

ZEROS

Distinct	8879
Distinct (%)	7.4%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	101.8311215

Minimum	-6.38
Maximum	5400
Zeros	1959
Zeros (%)	1.6%
Negative	1
Negative (%)	< 0.1%
Memory size	932.9 KiB

Quantile statistics

Minimum	-6.38
5-th percentile	38.4
Q1	69.29
median	94.575
Q3	126
95-th percentile	193.5
Maximum	5400
Range	5406.38
Interquartile range (IQR)	56.71

Descriptive statistics

Standard deviation	50.53579029
Coefficient of variation (CV)	0.4962705853
Kurtosis	1013.189851
Mean	101.8311215
Median Absolute Deviation (MAD)	27.825
Skewness	10.53021398
Sum	12157617.6
Variance	2553.8661
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
62	3754	3.1%
75	2715	2.3%
90	2473	2.1%
65	2418	2.0%
0	1959	1.6%
80	1889	1.6%
95	1661	1.4%
120	1607	1.3%
100	1573	1.3%
85	1538	1.3%
Other values (8869)	97803	81.9%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
-6.38	1	< 0.1%
0	1959	1.6%
0.26	1	< 0.1%
0.5	1	< 0.1%
1	15	< 0.1%
1.29	1	< 0.1%
1.48	1	< 0.1%
1.56	2	< 0.1%
1.6	1	< 0.1%
1.8	1	< 0.1%

Value	Count	Frequency (%)
5400	1	< 0.1%
510	1	< 0.1%
508	1	< 0.1%
451.5	1	< 0.1%
450	1	< 0.1%
437	1	< 0.1%
426.25	1	< 0.1%
402	1	< 0.1%
397.38	1	< 0.1%
392	2	< 0.1%

required_car_parking_spaces
Categorical

Distinct	5
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	932.9 KiB

0	111974
1	7383
2	28
3	3
8	2

Length

Max length	1
Median length	1
Mean length	1
Min length	1

Characters and Unicode

Total characters	119390
Distinct characters	5
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	0
2nd row	0
3rd row	0
4th row	0
5th row	0

Common Values

Value	Count	Frequency (%)
0	111974	93.8%
1	7383	6.2%
2	28	< 0.1%
3	3	< 0.1%
8	2	< 0.1%

Length

Histogram of lengths of the category

Category Frequency Plot

Value	Count	Frequency (%)
0	111974	93.8%
1	7383	6.2%
2	28	< 0.1%
3	3	< 0.1%
8	2	< 0.1%

Most occurring characters

Value	Count	Frequency (%)
0	111974	93.8%
1	7383	6.2%
2	28	< 0.1%
3	3	< 0.1%
8	2	< 0.1%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	119390	100.0%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
0	111974	93.8%
1	7383	6.2%
2	28	< 0.1%
3	3	< 0.1%
8	2	< 0.1%

Most occurring scripts

Value	Count	Frequency (%)
Common	119390	100.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
0	111974	93.8%
1	7383	6.2%
2	28	< 0.1%
3	3	< 0.1%
8	2	< 0.1%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	119390	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
0	111974	93.8%
1	7383	6.2%
2	28	< 0.1%
3	3	< 0.1%
8	2	< 0.1%

total_of_special_requests
Real number (ℝ_≥0)

ZEROS

Distinct	6
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	0.5713627607

Minimum	0
Maximum	5
Zeros	70318
Zeros (%)	58.9%
Negative	0
Negative (%)	0.0%
Memory size	932.9 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	1
95-th percentile	2
Maximum	5
Range	5
Interquartile range (IQR)	1

Descriptive statistics

Standard deviation	0.7927984228
Coefficient of variation (CV)	1.387557043
Kurtosis	1.492564811
Mean	0.5713627607
Median Absolute Deviation (MAD)	0
Skewness	1.349189377
Sum	68215
Variance	0.6285293392
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=6)

Value	Count	Frequency (%)
0	70318	58.9%
1	33226	27.8%
2	12969	10.9%
3	2497	2.1%
4	340	0.3%
5	40	< 0.1%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	70318	58.9%
1	33226	27.8%
2	12969	10.9%
3	2497	2.1%
4	340	0.3%
5	40	< 0.1%

Value	Count	Frequency (%)
5	40	< 0.1%
4	340	0.3%
3	2497	2.1%
2	12969	10.9%
1	33226	27.8%
0	70318	58.9%

reservation_status
Categorical

HIGH CORRELATION
HIGH CORRELATION

Distinct	3
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	932.9 KiB

Check-Out	75166
Canceled	43017
No-Show	1207

Length

Max length	9
Median length	9
Mean length	8.619473993
Min length	7

Characters and Unicode

Total characters	1029079
Distinct characters	17
Distinct categories	3 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Canceled
2nd row	Canceled
3rd row	Canceled
4th row	Canceled
5th row	Canceled

Common Values

Value	Count	Frequency (%)
Check-Out	75166	63.0%
Canceled	43017	36.0%
No-Show	1207	1.0%

Length

Histogram of lengths of the category

Category Frequency Plot

Value	Count	Frequency (%)
check-out	75166	63.0%
canceled	43017	36.0%
no-show	1207	1.0%

Most occurring characters

Value	Count	Frequency (%)
e	161200	15.7%
C	118183	11.5%
c	118183	11.5%
h	76373	7.4%
-	76373	7.4%
u	75166	7.3%
t	75166	7.3%
O	75166	7.3%
k	75166	7.3%
a	43017	4.2%
Other values (7)	135086	13.1%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	756943	73.6%
Uppercase Letter	195763	19.0%
Dash Punctuation	76373	7.4%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
e	161200	21.3%
c	118183	15.6%
h	76373	10.1%
u	75166	9.9%
t	75166	9.9%
k	75166	9.9%
a	43017	5.7%
n	43017	5.7%
l	43017	5.7%
d	43017	5.7%
Other values (2)	3621	0.5%

Uppercase Letter

Value	Count	Frequency (%)
C	118183	60.4%
O	75166	38.4%
N	1207	0.6%
S	1207	0.6%

Dash Punctuation

Value	Count	Frequency (%)
-	76373	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	952706	92.6%
Common	76373	7.4%

Most frequent character per script

Latin

Value	Count	Frequency (%)
e	161200	16.9%
C	118183	12.4%
c	118183	12.4%
h	76373	8.0%
u	75166	7.9%
t	75166	7.9%
O	75166	7.9%
k	75166	7.9%
a	43017	4.5%
n	43017	4.5%
Other values (6)	92069	9.7%

Common

Value	Count	Frequency (%)
-	76373	100.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	1029079	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
e	161200	15.7%
C	118183	11.5%
c	118183	11.5%
h	76373	7.4%
-	76373	7.4%
u	75166	7.3%
t	75166	7.3%
O	75166	7.3%
k	75166	7.3%
a	43017	4.2%
Other values (7)	135086	13.1%

reservation_status_date
Categorical

HIGH CARDINALITY

Distinct	926
Distinct (%)	0.8%
Missing	0
Missing (%)	0.0%
Memory size	932.9 KiB

21/10/2015	1461
6/7/2015	805
25/11/2016	790
1/1/2015	763
18/01/2016	625
Other values (921)	114946

Length

Max length	10
Median length	10
Mean length	9.387536645
Min length	8

Characters and Unicode

Total characters	1120778
Distinct characters	11
Distinct categories	2 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	28 ?
Unique (%)	< 0.1%

Sample

1st row	21/10/2015
2nd row	21/10/2015
3rd row	21/10/2015
4th row	21/10/2015
5th row	21/10/2015

Common Values

Value	Count	Frequency (%)
21/10/2015	1461	1.2%
6/7/2015	805	0.7%
25/11/2016	790	0.7%
1/1/2015	763	0.6%
18/01/2016	625	0.5%
2/7/2015	469	0.4%
7/12/2016	450	0.4%
18/12/2015	423	0.4%
9/2/2016	412	0.3%
4/4/2016	382	0.3%
Other values (916)	112810	94.5%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
21/10/2015	1461	1.2%
6/7/2015	805	0.7%
25/11/2016	790	0.7%
1/1/2015	763	0.6%
18/01/2016	625	0.5%
2/7/2015	469	0.4%
7/12/2016	450	0.4%
18/12/2015	423	0.4%
9/2/2016	412	0.3%
4/4/2016	382	0.3%
Other values (916)	112810	94.5%

Most occurring characters

Value	Count	Frequency (%)
/	238780	21.3%
1	218578	19.5%
0	196933	17.6%
2	187927	16.8%
6	79165	7.1%
7	60096	5.4%
5	46838	4.2%
3	26867	2.4%
8	23119	2.1%
9	21359	1.9%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	881998	78.7%
Other Punctuation	238780	21.3%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
1	218578	24.8%
0	196933	22.3%
2	187927	21.3%
6	79165	9.0%
7	60096	6.8%
5	46838	5.3%
3	26867	3.0%
8	23119	2.6%
9	21359	2.4%
4	21116	2.4%

Other Punctuation

Value	Count	Frequency (%)
/	238780	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Common	1120778	100.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
/	238780	21.3%
1	218578	19.5%
0	196933	17.6%
2	187927	16.8%
6	79165	7.1%
7	60096	5.4%
5	46838	4.2%
3	26867	2.4%
8	23119	2.1%
9	21359	1.9%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	1120778	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
/	238780	21.3%
1	218578	19.5%
0	196933	17.6%
2	187927	16.8%
6	79165	7.1%
7	60096	5.4%
5	46838	4.2%
3	26867	2.4%
8	23119	2.1%
9	21359	1.9%

Spearman's ρ

The Spearman's rank correlation coefficient (ρ) is a measure of monotonic correlation between two variables, and is therefore better in catching nonlinear monotonic correlations than Pearson's r. It's value lies between -1 and +1, -1 indicating total negative monotonic correlation, 0 indicating no monotonic correlation and 1 indicating total positive monotonic correlation.

To calculate ρ for two variables X and Y, one divides the covariance of the rank variables of X and Y by the product of their standard deviations.

Pearson's r

The Pearson's correlation coefficient (r) is a measure of linear correlation between two variables. It's value lies between -1 and +1, -1 indicating total negative linear correlation, 0 indicating no linear correlation and 1 indicating total positive linear correlation. Furthermore, r is invariant under separate changes in location and scale of the two variables, implying that for a linear function the angle to the x-axis does not affect r.

To calculate r for two variables X and Y, one divides the covariance of X and Y by the product of their standard deviations.

Kendall's τ

Similarly to Spearman's rank correlation coefficient, the Kendall rank correlation coefficient (τ) measures ordinal association between two variables. It's value lies between -1 and +1, -1 indicating total negative correlation, 0 indicating no correlation and 1 indicating total positive correlation.

To calculate τ for two variables X and Y, one determines the number of concordant and discordant pairs of observations. τ is given by the number of concordant pairs minus the discordant pairs divided by the total number of pairs.

Cramér's V (φc)

Cramér's V is an association measure for nominal random variables. The coefficient ranges from 0 to 1, with 0 indicating independence and 1 indicating perfect association. The empirical estimators used for Cramér's V have been proved to be biased, even for large samples. We use a bias-corrected measure that has been proposed by Bergsma in 2013 that can be found here.

Phik (φk)

Phik (φk) is a new and practical correlation coefficient that works consistently between categorical, ordinal and interval variables, captures non-linear dependency and reverts to the Pearson correlation coefficient in case of a bivariate normal input distribution. There is extensive documentation available here.

A simple visualization of nullity by column.

Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.

The correlation heatmap measures nullity correlation: how strongly the presence or absence of one variable affects the presence of another.

The dendrogram allows you to more fully correlate variable completion, revealing trends deeper than the pairwise ones visible in the correlation heatmap.

First rows

	Unnamed: 0	hotel	is_canceled	lead_time	arrival_date_year	arrival_date_month	arrival_date_week_number	arrival_date_day_of_month	stays_in_week_nights	adults	meal	country	market_segment	distribution_channel	reserved_room_type	assigned_room_type	deposit_type	agent	company	customer_type	adr	reservation_status	reservation_status_date
0	0	City Hotel	1	615	2017	March	11	16	2	2	BB	PRT	Groups	TA/TO	A	A	Non Refund	1.0	NaN	Transient	62.0	Canceled	21/10/2015
1	1	City Hotel	1	615	2017	March	11	16	2	2	BB	PRT	Groups	TA/TO	A	A	Non Refund	1.0	NaN	Transient	62.0	Canceled	21/10/2015
2	2	City Hotel	1	615	2017	March	11	16	2	2	BB	PRT	Groups	TA/TO	A	A	Non Refund	1.0	NaN	Transient	62.0	Canceled	21/10/2015
3	3	City Hotel	1	615	2017	March	11	16	2	2	BB	PRT	Groups	TA/TO	A	A	Non Refund	1.0	NaN	Transient	62.0	Canceled	21/10/2015
4	4	City Hotel	1	615	2017	March	11	16	2	2	BB	PRT	Groups	TA/TO	A	A	Non Refund	1.0	NaN	Transient	62.0	Canceled	21/10/2015
5	5	City Hotel	1	615	2017	March	11	16	2	2	BB	PRT	Groups	TA/TO	A	A	Non Refund	1.0	NaN	Transient	62.0	Canceled	21/10/2015
6	6	City Hotel	1	615	2017	March	11	16	2	2	BB	PRT	Groups	TA/TO	A	A	Non Refund	1.0	NaN	Transient	62.0	Canceled	21/10/2015
7	7	City Hotel	1	615	2017	March	11	16	2	2	BB	PRT	Groups	TA/TO	A	A	Non Refund	1.0	NaN	Transient	62.0	Canceled	21/10/2015
8	8	City Hotel	1	615	2017	March	11	16	2	2	BB	PRT	Groups	TA/TO	A	A	Non Refund	1.0	NaN	Transient	62.0	Canceled	21/10/2015
9	9	City Hotel	1	615	2017	March	11	16	2	2	BB	PRT	Groups	TA/TO	A	A	Non Refund	1.0	NaN	Transient	62.0	Canceled	21/10/2015

Last rows

	Unnamed: 0	hotel	is_canceled	lead_time	arrival_date_year	arrival_date_month	arrival_date_week_number	arrival_date_day_of_month	stays_in_weekend_nights	stays_in_week_nights	adults	children	meal	country	market_segment	distribution_channel	reserved_room_type	assigned_room_type	booking_changes	deposit_type	agent	company	customer_type	adr	total_of_special_requests	reservation_status	reservation_status_date
119380	119380	City Hotel	1	65	2016	July	29	14	0	3	2	0.0	BB	PRT	Direct	Direct	E	E	0	No Deposit	14.0	NaN	Transient	139.50	0	Canceled	10/5/2016
119381	119381	City Hotel	1	93	2016	July	29	14	1	3	2	1.0	BB	CHN	Online TA	TA/TO	A	A	0	No Deposit	9.0	NaN	Transient	109.35	0	Canceled	19/04/2016
119382	119382	City Hotel	1	91	2016	July	29	14	1	3	2	0.0	BB	FRA	Online TA	TA/TO	D	D	0	No Deposit	9.0	NaN	Transient	118.80	0	Canceled	22/04/2016
119383	119383	City Hotel	1	132	2016	July	29	14	2	4	2	1.0	BB	FRA	Online TA	TA/TO	A	A	0	No Deposit	9.0	NaN	Transient	114.75	0	Canceled	23/04/2016
119384	119384	City Hotel	1	162	2016	July	29	14	2	5	2	0.0	SC	GBR	Online TA	TA/TO	A	A	0	No Deposit	9.0	NaN	Transient	86.82	0	Canceled	13/05/2016
119385	119385	City Hotel	1	150	2016	July	29	14	2	8	3	0.0	BB	FRA	Online TA	TA/TO	D	D	0	No Deposit	9.0	NaN	Transient	131.75	2	Canceled	31/03/2016
119386	119386	City Hotel	1	150	2016	July	29	14	2	8	2	0.0	BB	FRA	Online TA	TA/TO	A	A	0	No Deposit	9.0	NaN	Transient	101.15	1	Canceled	31/03/2016
119387	119387	City Hotel	1	60	2016	July	29	15	0	1	3	0.0	BB	PRT	Online TA	TA/TO	D	D	0	No Deposit	9.0	NaN	Transient	137.70	1	Canceled	7/7/2016
119388	119388	City Hotel	1	9	2016	July	29	15	0	1	3	0.0	BB	FRA	Online TA	TA/TO	D	D	0	No Deposit	9.0	NaN	Transient	197.00	1	Canceled	13/07/2016
119389	119389	City Hotel	0	194	2016	July	29	15	0	1	2	0.0	BB	CHE	Online TA	TA/TO	B	B	1	No Deposit	9.0	NaN	Transient-Party	86.75	0	Check-Out	16/07/2016

Overview

Variables

Common Values

Length

Category Frequency Plot

Most occurring characters

Most occurring categories

Most frequent character per category

Lowercase Letter

Uppercase Letter

Space Separator

Most occurring scripts

Most frequent character per script

Latin

Common

Most occurring blocks

Most frequent character per block

ASCII

Common Values

Length

Category Frequency Plot

Most occurring characters

Most occurring categories

Most frequent character per category

Decimal Number

Most occurring scripts

Most frequent character per script

Common

Most occurring blocks

Most frequent character per block

ASCII

Common Values

Length

Category Frequency Plot

Most occurring characters

Most occurring categories

Most frequent character per category

Decimal Number

Most occurring scripts

Most frequent character per script

Common

Most occurring blocks

Most frequent character per block

ASCII

Common Values

Length

Most occurring characters

Most occurring categories

Most frequent character per category

Lowercase Letter

Uppercase Letter

Most occurring scripts

Most frequent character per script

Latin

Most occurring blocks

Most frequent character per block

ASCII

Common Values

Length

Category Frequency Plot

Most occurring characters

Most occurring categories

Most frequent character per category

Decimal Number

Other Punctuation

Most occurring scripts

Most frequent character per script

Common

Most occurring blocks

Most frequent character per block

ASCII

Common Values

Length

Category Frequency Plot

Most occurring characters

Most occurring categories

Most frequent character per category

Decimal Number

Most occurring scripts

Most frequent character per script